Database Files Readme


CTDDB_UPcasts_1993-2019 is an Access database that contains all the CalCOFI CTD 1m upcasts final data.
CTDDB_DOWNcasts_1993-2019 is an Access database that contains all the CalCOFI CTD downcasts 1m final data.

Since both these databases are close to the 2gb maximum table size limit. If you run a Make Table Query, 
you may have to port the output to a separate database, depending on the number of records. 
The Upcast or Downcast databases may not have the capacity to save a large new table.


Since Access has a 2gb limit, in order to have a complete 9308NH-1911NH queryable table, the upcasts and
downcasts had to be separated. You can link the tables or migrate them to SQL Server or other databases
that allow a database larger than 2gb.


CTD_DowncastFinalCSV_1993-2019 is the single csv that was imported into the downcast database.
CTD_UpcastFinalCSV_1993-2019 is the single csv that was imported into the upcast database.

These csvs contain all the data records from the three decadal databases: 1993-1999, 2000-2009, & 2010-2019.
Newer cruise csvs can be imported into the appropriate database or appended onto the 1993-2019 downcast or upcast csvs.


CalCOFI_CTD_UpcastFinalDataCSVs_1993-2019 includes the separate upcast csv text files from the three decadal databases. Plus
two versions of the merged csvs - one with the ID column, one without the ID column. When importing the entire dataset
into a new database table. I found using the csv without ID column works better since the database will assign a primary key value.
The ID column is Access' primary key. Since there were three Access databases, the ID key did not continue from one database
to the next.

CalCOFI_CTD_DowncastFinalDataCSVs_1993-2019 includes the separate downcast csv text files from the three decadal databases. Plus
two versions of the merged csvs - one with the ID column, one without the ID column.






James Wilkinson
SIO-CalCOFI Technical Group
07/11/2024